﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Collections.Specialized;
using System.Data.SqlClient;
using System.Data;

namespace POSSystem.BLL
{
    public class CustomerStatementReport : CommonReport
    {
        private int customer;

        public int Customer
        {
            get { return customer; }
            set { customer = value; }
        }

        private DateTime from;

        public DateTime From
        {
            get { return from; }
            set { from = value; }
        }
        private DateTime to;

        public DateTime To
        {
            get { return to; }
            set { to = value; }
        }

        public override void LoadReport(String storeProc)
        {
            ListDictionary parameters = new ListDictionary();

            parameters.Add(new SqlParameter("@from", SqlDbType.DateTime, 0), from);
            parameters.Add(new SqlParameter("@to", SqlDbType.DateTime, 0), to);
            parameters.Add(new SqlParameter("@customerID", SqlDbType.Int, 0), customer);
            parameters.Add(new SqlParameter("@branchID", SqlDbType.Int, 0), branchID);

            LoadFromSql(storeProc, parameters);
        }
    }
}
